package com.zzyl.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UserRoleMapper {

    @Select("select sr.* from sys_user_role  sur left join sys_role sr on sur.role_id = sr.id where sr.role_name  = #{roleName}")
    List<Long> selectByRoleName(String roleName);

    @Select("select sr.* from sys_user_role  sur left join sys_role sr on sur.role_id = sr.id where sr.role_name  = #{roleName}")
    List<Long> selectUserIdsByRoleName(String deviceMaintainerRole);

}
